fridgetagmapping
Table: fridgetagmapping
The fridgetagmapping table stores the mapping between fridge tags and ILR (Ice-Lined Refrigerator) QR codes.
It tracks creation, modification, and voiding of these mappings for cold chain management.
Columns
| Column Name | Data Type | Constraints | Description |
|---|---|---|---|
| fridgeTagMappingId | int(11) | NOT NULL, AUTO_INCREMENT | Unique identifier for each fridge tag mapping |
| createdDate | datetime | NULL | Timestamp when the mapping record was created |
| lastEditedDate | datetime | NULL | Timestamp when the mapping record was last modified |
| fridgeTagQrCode | varchar(255) | NULL | QR code of the fridge tag |
| ilrQrCode | varchar(255) | NULL | QR code of the ILR unit |
| isVoided | tinyint(1) | NOT NULL | Flag indicating if the mapping is voided (1 = voided, 0 = active) |
| voidedDate | datetime | NULL | Timestamp when the mapping was voided |
| createdByUserId | int(11) | NULL | User who created the mapping record |
| lastEditedByUserId | int(11) | NULL | User who last edited the mapping record |
Indexes
- PRIMARY - Primary key on
fridgeTagMappingId
Foreign Key Relations
- None explicitly defined, but
createdByUserIdandlastEditedByUserIdtypically referenceuser.mappedId.
Usage Notes
- Maintains the link between fridge tags and ILR units for monitoring purposes.
isVoidedandvoidedDateallow tracking inactive or removed mappings.- Audit fields (
createdByUserId,lastEditedByUserId,createdDate,lastEditedDate) help maintain change history. - Useful for cold chain compliance reporting and fridge monitoring workflows.